🕷️️ Job Radar • SCRAPING

upwork.com 🟢 2026-05-12

🔹 Automated Newsletter System: Web Scraping → Google Sheets → AI Writer → Beehiiv
👤 Client: 🇺🇸 United States Member since 2012-03-09
💰 Price: ****
🚩 Problem: Need an automated workflow for collecting, organizing, writing, and publishing local/community-style newsletters.
📦 Existing: Not specified

Specifications:

[Target] Collect relevant information from selected websites
[Method] Use web scraping, RSS feeds, APIs
[UI/UX] Google Sheets template for data organization
[Stack] n8n, Apify, OpenAI / ChatGPT API, Beehiiv
[Security] Ensure data privacy and secure API access
[Format] Clean newsletter draft in Google Sheets

Workflow:

1. Define the list of websites to be scraped.
2. Set up web scraping using Apify or n8n for specific fields.
3. Organize collected data into a structured format (Google Sheets).
4. Use OpenAI / ChatGPT API to generate newsletter content based on Google Sheet inputs.
5. Prepare the AI-generated content in Beehiiv or export it as a draft.